Two Formula in one cell - SUM If higher than number and change

[greaty]

Sorry I'm very beginner at Excel.
I'm trying to create a spreadsheet for bookings on my house.
I'm trying to do two formulas into one cell.

Basically, i want the 'Remaining Balance' Cells to display the answer for "Booking Price" Minus "Deposit Paid'
EG: booking price is $100 - Deposit paid $50. Remaining Balance $50.
That is easy with just Cell 1 minus Cell 2 = remaining balance.
However, i also want the remaining balance to display "PAID" if the deposit paid cells are '0'

I've made a formula to do just that
=IF(G7=0,"PAID",F7)
So if the deposit cell is "0" a "PAID" will show up in the remaining balance.
How can I also add IF G7 is Greater than 1 then do the normal sum of F7-G7 to get the remaining balance.


=IF(G7=0,"PAID",F7) OR)IF) G7 <1 THEN do SUM F7-G7)
Something like that lol

Sorry if this is confusing!

 

[nemmi69]

=IF(G7=0,"PAID",IF( G7>1,F7-G7,F7))
so this means if G7=0 then set to "PAID" if not check if greater than 1. If it is F7-G7 otherwise set to F7

 

[Peter_SSs]

=IF(G7=0,"PAID",IF( G7>1,F7-G7,F7))
so this means if G7=0 then set to "PAID" if not check if greater than 1. If it is F7-G7 otherwise set to F7

Wouldn't that mean the first 2 rows in the OP's image also return "PAID" (unless column G is populated by a formula returning "", in which case an error would occur)?

@ greaty
Welcome to the MrExcel board!

This could be tried instead. I am also assuming that you don't really need G to be greater than 1, simply not 0.

23 08 29.xlsm
	F	G	H
6	Price	Deposit	Balance
7	90,000.00		90,000.00
8	195,000.00		195,000.00
9	1,340,000.00	0	PAID
10	1,160,000.00	348,000.00	812,000.00
11	1,120,000.00	336,000.00	784,000.00
12	930,000.00	0	PAID
Balance

Cell Formulas
Range	Formula
H7:H12	H7	=IF(G7&""="0","PAID",F7-G7)

If column G does happen to be a formula and those empty-looking cells actually contain "", then change the formula to

=IF(G7&""="0","PAID",F7-N(G7))

 

[greaty]

Wouldn't that mean the first 2 rows in the OP's image also return "PAID" (unless column G is populated by a formula returning "")?

@ greaty
Welcome to the MrExcel board!

This could be tried instead. I am also assuming that you don't really need G to be greater than 1, simply not 0.

23 08 29.xlsm
	F	G	H
6	Price	Deposit	Balance
7	90,000.00		90,000.00
8	195,000.00		195,000.00
9	1,340,000.00	0	PAID
10	1,160,000.00	348,000.00	812,000.00
11	1,120,000.00	336,000.00	784,000.00
12	930,000.00	0	PAID
Balance

Cell Formulas
Range	Formula
H7:H12	H7	=IF(G7&""="0","PAID",F7-G7)

If column G does happen to be a formula and those empty-looking cells actually contain "", then change the formula to

=IF(G7&""="0","PAID",F7-N(G7))

YES!! That worked perfectly!

Thank you very much, sorry for the confusion!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.