A1 = Initial Premium: 1000$
B1= Current Interest Rate:2.00%C1= Guaranteed Interest Rate:3.00%
And
Get value on D1
Need formula for D1 = A1*Which one is higher value (B1 or C1) i.e[Here C1 > B1]
A1 = Initial Premium: 1000$
B1= Current Interest Rate:2.00%C1= Guaranteed Interest Rate:3.00%
And
Get value on D1
Need formula for D1 = A1*Which one is higher value (B1 or C1) i.e[Here C1 > B1]
Last edited by raw_geek; 04-16-2012 at 06:08 PM.
Hi
Try this,in D1.
=IF(B1>C1;A1*B1;A1*C1)
Hope, this to help you.
Edit:
Change the semi colons, to comma, if you have to do this.
Last edited by Fotis1991; 04-16-2012 at 06:03 PM. Reason: Edit:
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Would this do the trick?
=A1*MAX(B1:C1)
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Work Work!!!
thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks