Hi guys,
Have some format of currency issues resulting a pronblem.
See K2 is not returning the coreect answer for F2-B2.
Can anyone advise why? please. thank you
Hi guys,
Have some format of currency issues resulting a pronblem.
See K2 is not returning the coreect answer for F2-B2.
Can anyone advise why? please. thank you
Thanks,
R.
F2 = -4084.22448 even though you have it formatted to be positive. Do you expect it to be positive? or did you want to force it to be positive (Use ABS(formula) in F2)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
you have a dodgy format on f2 that doesn't show a negative try formating as a normal currency format
in f2
=D2*(E2-1) is 4167x(0.02-1)= -4084
try d2*(1-e2) instead
thank you davsth
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks