Subtract or leave blank in cell

P

pano

Hi all, how would I write this in cell G14

=E14-E13 if F14 cell has a number otherwise be blank

E F G
13 100 50 50
14 50 0


Thanks Stephen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
Overtime Calculations 1
Passed Arguments to a UDF 9
Using two Vlookup in one Cell 1
Formula ... Minus Holidays? 1
Formula confusion 3
Conditional Formatting - Excel 2003 2
Setting a cell with a value as a reference for another function 1

Top